forum

Home / DeveloperSection / Forums / How to masked the email ID in SQL Server?

Ask Question
Ashutosh Kumar Verma

Ashutosh Kumar Verma

Follow
Hi! This is Ashutosh Kumar Verma. I am a software developer at MindStick Software Pvt Ltd since 2021. I have added some new and interesting features to the MindStick website like a story section, audio section, and merge profile feature on MindStick subdomains, etc. I love coding and I have good knowledge of SQL Database.

Can you answer this question?

Answer

1 Answers

Khushi Singh

Khushi Singh

03-Jan-2025

To mask an email ID in SQL Server, one can use the STUFF function to remove some characters, put * on the result set, and put back some characters at the end.

Example Query:

SELECT 
   Email,
   STUFF(Email, CHARINDEX('@', Email) - 3, 3, '***') AS MaskedEmail
FROM 
   YourTable;

Explanation:

  1. CHARINDEX('@', Email): Finds the position of the @ symbol in the email.
  2. STUFF: Replaces the characters starting 3 characters before the @ with ***.

Hope it helps!!

 

 

 

 

 

 

 

 

 

 

 

 

 

Liked By